Insights / Google BigQuery

Create a dashboard with access to both your current data collected from GA4 and all of your historic data from GA3....

Unlock more flexibility around data use cases, as well as removing limitations when populating dynamic data into a Looker Studio dashboard....

If you are a Looker Studio power user, you are probably connecting to a Google Sheet as a table for select datasets and manually updating your sheet several times per month...

For analyses, working with SQL on nested data can be very performant because nested data with arrays basically means working on pre-joined tables...